You are here: Tools > Mapper > Mapper I > File Layouts > PAY34T Batch Time Card Transaction File

PAY34T Batch Time Card Transaction File

File Type Physical  
Record Format PAY34R  
Key Files GTC Transaction code
  JEMPNO Employee Number
  JPAYS Pay Separator
  • Every record must end with a carriage return/line feed.
ClosedTCW - Header Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC W
Not Used A 8      
Week End Date N 6 0 GWEDT ddmmyy
Period Number N 2 0 GPERNO  
Payrun Group Code A 4   GPAYGR Valid Payrun Group code (PCTLAA)
Pay Frequency Selection (1) A 1   GFSELI
ClosedActions

A - Half Monthly
F - Fortnightly
M - Monthly
W - Weekly
4 - Four Weekly
Pay Frequency Selection (2) A 1   GFSEL2
ClosedActions

A - Half Monthly
F - Fortnightly
M - Monthly
W - Weekly
4 - Four Weekly
Pay Frequency Selection (3) A 1   GFSEL3
ClosedActions

A - Half Monthly
F - Fortnightly
M - Monthly
W - Weekly
4 - Four Weekly
Auto Pay Required A 1   GAUTOF Y or N
Generate Standard A/D's A 1   GSTDAD Y or N
Generate Occupational Super A 1   GOCSUP Y or N
Pay to Date (Weekly N 6 0 GWKPTD ddmmyy
Pay to Date (Fortnightly) N 6 0 GFNPTD ddmmyy
Pay to Date ( 4 Weekly) N 6 0 G4WPTD ddmmyy
Message - Part 1 A 28   GMSG1  
Message - Part 2 (A) A 8   GMSG2A  
DFU Record Number A 5   GDFU#  
Message - Part 2 (B) A 24   GMSG2B  
Default Hours Type (1) A 2   GHRS1 Valid Hours Type Code (PCTLAH)
Default Hours Type (2) A 2   GHRS2 Valid Hours Type Code (PCTLAH)
Default Hours Type (3) A 2   GHRS3 Valid Hours Type Code (PCTLAH)
Default Hours Type (4) A 2   GHRS4 Valid Hours Type Code (PCTLAH)

 

ClosedTC1 - Worked Hours Records
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC 1
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GPAYS  
Hours Type (1) A 2   G$T,1 Valid Hours Type Code (PCTLAH)
Worked Hours (1) N 5 2 G$5,1  
Calculation Method Override (1) A 2   G$L,1 Valid Calculation Method Code (PCTLAL)
Hours Type (2) A 2   G$T,2 Valid Hours Type Code (PCTLAH)
Worked Hours (2) N 5 2 G$5,2  
Calculation Method Override (2) A 2   G$L,2 Valid Calculation Method Code (PCTLAL)
Hours Type (3) A 2   G$T,3 Valid Hours Type Code (PCTLAH)
Worked Hours (3) N 5 2 G$5,3  
Calculation Method Override (3) A 2   G$L,3 Valid Calculation Method Code (PCTLAL)
Hours Type (4) A 2   G$T,4 Valid Hours Type Code (PCTLAH)
Worked Hours (4) N 5 2 G$5,4  
Calculation Method Override (4) A 2   G$L,4 Valid Calculation Method Code (PCTLAL)
Not Used A 1      
Suppress Auto Pay A 1   GAPS
ClosedOptions

Y - Suppress Auto Pay
R - Suppress RDO
B - Suppress Auto/RDO
Pay Method Override A 1   GPAYM
ClosedOptions

E - Envelope/Cash
B - Bank Credit
C - Cheque
N - No output
Tax Weeks Override N 2 0 GTXW  
Deduction Lots Override N 2 0 GDEDL  
Salary Code Override A 4   GSALC Valid Salary Code (PCTLBS)
Base Pay Rate Override N 7 4 GBPAY  
Account Number Override A 10   GACCT  
Job/Department Number Override A 8   GDEPT  
DFU Record Number N 5 0 GDFU#  
Costing Date N 6 0 GDATE ddmmyy
User Field 1 A 10   GUSER1  
User Field 2 A 10   GUSER2  
User Field 3 A 10   GUSER3  
User Field 4 A 5   GUSER4  
Not Used A 1      
Entry Source A 3   GSRCE  
Source TXN ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Not Used A 40      
Job Costing Work ID N 3 0 GCWKID  
Job Costing Job Number A 6   GJOB  
Job Costing Cost Code A 8   GCODE  
Job Costing Cost Type A 2   GTYP  
Job Costing G/L Account Number A 10   GGLAC  
Job Costing Resource Code A 10   GRSCCD  
Job Costing Asset Code A 6   GASSCD  
Job Costing Asset Type A 2   GASTYP  
Not Used A 56      
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  
Not Used A 10      
Not Used A 10      
Not Used A 10      

 

ClosedTC2 - Allowances/Deductions Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC 2
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GPAYS  
Allowance/Deduction Type (1) A 2   G$T,1 Valid Allowance/Deduction Code (PCTLAZ)
Allowance/Deduction Units (1) N 7 2 G$8,1  
Allowance/Deduction Rate (1) N 9 4 G$7,1  
Allowance/Deduction Type (2) A 2   G$T,2 Valid Allowance/deduction Code (PCTLAZ)
Allowance/Deduction Units (2) N 7 2 G$8,2  
Allowance/Deduction Rate (2) N 9 4 G$7,2  
Not Used A 1      
Suppress Auto Pay A 1   GAPS
ClosedOptions

Y - Suppress Auto Pay
R - Suppress RDO
B - Suppress Auto/RDO
" - No
Pay Method Override A 1   GPAYM
ClosedOptions

E - Envelope
B - Bank Credit
C - Cheque
N - No Output
" - No Override
Tax Weeks Override N 2 0 GTXW  
Deduction Lots Override N 2 0 GDEDL  
Salary Code Override A 4   GSALC Valid Salary Code (PCTLBS)
Base Pay Rate Override N 7 4 GBPAY  
Account Number Override A 10   GACCT  
Job/Department Number Override N 8   GDEPT  
DFU Record Number N 5 0 GDFU#  
Costing Date N 6 0 GDATE ddmmyy
Reserved for System Use A 10   GUSER1  
Reserved for System Use A 10   GUSER 2  
Reserved for System Use A 10   GUSER 3  
Reserved for System Use A 5   GUSER4  
Not Used A 1      
Entry Source A 3   GSRCE  
Source TX ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Not Used A 40      
Job Costing Work ID N 3 0 GCWKID  
Job Costing Job Number A 6   GJOB  
Job Costing Cost Code A 8   GCODE  
Job Costing Cost Type A 2   GTYP  
Job Costing G/L Account Number A 10   GGLAC  
Job Costing Resource Code A 10   GRSCCD  
Job Costing Asset Code A 6   GASSCD  
Job Costing Asset Type A 2   GASTYP  
Not Used A 56      
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  
Not Used A 10      
Not Used A 10      
Not Used A 10      

 

ClosedTC3 - Tax Adjustment Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC 3
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GPAYS  
Not Used A 10      
Tax Adjustment Amount N 9 2 G$7,1  
Not Used A 54      
DFU Record Number N 5 0 GDFU#  
Not Used A 393      

 

ClosedTC6 - Leave with Dates Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC 6
Employee Number A 6 0 GEMPNO  
Not Used A 1      
Pay Separator A 1   GPAYS  
Leave Hours Type A 2   G$T,1 Valid Hours Type Code (PCTLAH) with A, S or L classification
Leave Hours N 5 2 G$5,1  
Calculation Method Override A 2   G$L,1 Valid Calculation Method Code (PCTLAL)
Other Leave Reason A 2   G$T,2 Valid Leave Reason Code (PCTLAA)
Start Date of Leave N 6 0 G$6,1 ddmmyy
Doctor's Cert./Authorised A 1   G$T,3 Position 1
ClosedOptions

Y - Yes
N - No
Force Payment A 1   G$T,3 Position 2
ClosedOptions

Y - Yes
N - Do not pay
If left blank, the Leave Rules specified in the Reference Tables will apply.
End Date of Leave N 6 0 G$6,2 ddmmyy
Continued from Previous Pay Period A 1   GCONT
ClosedOptions

Y - Yes
N - No
W/C Claim Number/Comment A 8   GCLAIM  
Not Used A 3      
Suppress Auto Pay A 1   GAPS
ClosedOptions

Y - Suppress Auto Pay
R - Suppress RDO
B - Suppress Auto/RDO
Pay Method Override A 1   GPAYM
ClosedOptions

E - Envelope
B - Bank Credit
C - Cheque
N - No Output
Tax Weeks Override N 2 0 GTXW  
Deduction Lots Override N 2 0 GDEDL  
Salary Code Override A 4   GSALC Valid Salary Code (PCTLBS)
Base Pay Rate Override N 7 4 GBPAY  
Account Number Override A 10   GACCT  
Job/Department Number Override A 8   CDEPT  
DFU Record Number N 5 0 GDFU#  
GDays A 5     NZ Only
Not Used A 37      
Entry Source A 3   GSRCE  
Source TXN ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Not Used A 40      
Job Costing Work ID N 3 0 GCWKID  
Not Used A 100      
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  
Not Used A 10      
Not Used A 10      
Not Used A 10      

 

ClosedTC7 - Termination Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC 7
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GPAYS  
Termination Reason A 2   G$T,1 Valid Termination Reason Code (PCTLAA)
Termination Date N 6 0 G$6,1 ddmmyy
Lump Sum A Allowance Code A 2   G$T,2 Valid Allowance/Deduction Code (PCTLAZ) with A classification
Lump Sum A Amount N 9 2 G$7,1  
Lump Sum Allowance Code A 2   G$T,3 Valid Allowance/Deduction Code (PCTLAZ) with B classification
Lump Sum B Amount N 9 2 G$7,2  
Lump Sum C Allowance Code A 2   G$T,4 Valid Allowance/Deduction Code (PCTLAZ) with C classification
Lump Sum C Amount N 9 2 G$7,3  
Suppress Auto Pay A 1   GAPS
ClosedOptions

Y - Suppress Auto Pay
R - Suppress RDO
B - Suppress Auto/RDO
Pay Method Override A 1   GPAYM
ClosedOptions

E - Envelope
B - Bank Credit
C - Cheque
N - No Output
Not Used A 11      
Account Number Override A 10   GACCT  
Job/Department Number Override A 8   GDEPT  
DFU Record Number N 5 0 GDFU#  
Base Pay Rate N 7 4 GBPAY  
Not Used A 10      
Not Used A 10      

 

ClosedTC9 - Costing Adjustment/Transfer Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC 9
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GPAYS  
Record Type A 1   GADJTR
ClosedOptions

A - Adjustment
T - Transfer

Base Pay Rate Override N 7 4 GBPAY  
From Account Number A 10   GFACCT  
To Account Number A 10   GACCT  
From Job/Department Number A 8   GFDEPT  
To Job/Department Number A 8   GDEPT  
Hours Type A 2   GHRT Valid Hours Type code (PCTLAH)
Hours Worked N 6 2 GHRS  
Hours $ Value N 7 2 GHRVAL  
Allowance/Deduction Type A 2   GADT Valid Allowance/Deduction Code (PCTLZ)
Allowance/Deduction Value N 9 2 GADVAL  
Not Used A 2      
DFU Record Number N 5 0 GDFU#  
Costing Date N 6 0 GDATE ddmmyy
Not Used A 36      
Entry Source A 3   GSRCE  
Source TXN ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Labour Cost Code 1 To A 10   TLCST1  
Labour Cost Code 2 To A 10   TLCST2  
Labour Cost Code 3 To A 20   TLCST3  
Job Costing Work ID A 3   GCWKID  
Job Costing Job Number A 6   GJOB  
Job Costing Cost Code A 8   GCODE  
Job Costing Cost Type A 2   GTYP  
Job Costing G/L Account Number A 10   GGLAC  
Job Costing Resource Code A 10   GRSCCD  
Job Costing Asset Code A 6   GASSCD  
Job Costing Asset Type A 2   GASTYP  
JP to Costing Work ID A 3   TCWKID  
JP to Job Number A 6   TJOB  
JP to Cost Code A 8   TCODE  
JP to Cost Type A 2   TCTYP  
JP to G/L Account Number A 10   TGLAC  
JP to Resource Code A 10   TRSSCD  
JP to Asset Code A 6   TASSCD  
JP to Asset Type A 3   TASSSTYP  
  A 8   NOT USED  
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  
User Codes Code 1 To A 10   TLCST4  
User Cost Code 2 To A 10   TLCST5  
User Cost Code 3 To A 10   TLCST6  

 

ClosedTC A - Prepayment Termination Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC A
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GAPYS  
Termination Reason Code A 2   GTRMRS G$T,1 Valid Termination Reason Code (PCTLAA)
Termination Date N 6 0 G$6,1 ddmmyy
Not Used A 64      
DFU Record Number N 5 0 GDFU#  
Not Used A 394      

 

ClosedTC B - Prepayment Allowance/Deductions Records
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC B
Employee Number A 6   GEMPNO  
  A 1   GEMPC  
Pay Separator A 1   GAPSY  
Allowance/Deduction Code (1) A 2   G$T,1 Valid Allowance/Deduction Code (PCTLAZ)
Allowance/Deduction Units (1) N 7 2 G$8,1  
Allowance/Deduction Value (1) N 9 2 G$7,1  
Allowance/Deduction Code (2) A 2   G$T,2 Valid Allowance/Deduction Code (PCTLAZ)
Allowance/Deduction Units (2) N 7 2 G$8,2  
Allowance/Deduction Value (2) N 9 2 G$7,2  
Not Used A 18      
Account Number Override A 10   GACCT  
Job/Department Number Override A 8   GDEPT  
DFU Record Number N 5 0 GDFU#  
Costing Date N 6 0 GDATE ddmmyy
Not Used A 36      
Entry Source A 3   GSRCE  
Source TXN ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Not Used A 40      
Job Costing Work ID A 3   GCWKID  
Not Used A 100      
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  
Not Used A 10      
Not Used A 10      
Not Used A 10      

 

ClosedTC C - Prepayment Worked Hours Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC C
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GPAYS  
Hours Type Code (1) A 2   G$T,1 Valid Hours Type Code (PCTLAH)
Worked Hours (1) N 5 2 G$5,1  
Hours Value (1) N 9 2 G$7,1  
Hours Type Code (2) A 2   G$T,2 Valid Hours Type Code (PCTLAH)
Worked Hours (2) N 5 2 G$5,2  
Hours Value (2) N 9 2 G$7,2  
Hours Type Code (3) A 2   G$T,3 Valid Hours Type Code (PCTLAH)
Worked Hours (3) A 5   G$5,3  
Hours Value (3) A 9   G$7,3  
Not Used A 6      
Account Number Override A 10   GACCT  
Job/Department Number Override A 8   GDEPT  
DFU Record Number N 5 0 GDFU#  
Costing Date N 6 0 GDATE ddmmyy
Not Used A 36      
Entry Source A 3   GSRCE  
Source TXN ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Not Used A 40      
Job Costing Work ID A 3   GCWKID  
Not Used A 100      
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  

 

ClosedTC D - Prepayment Leave with Dates Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC D
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GPAYS  
Leave Hours Type A 2   G$T,1 Valid Hours Type Code (PCTLAH) with A, S or L classification
Leave Hours Taken N 5 2 G$5,1  
Leave Hours Value N 9 2 G$7,1  
Other Leave Reason A 2   G$T,2 Valid Leave Reason Code (PCTLAA)
Start Date of Leave N 6 2 G$6,1 ddmmyy
Doctor's Cert./Authorised N 1   G$T,3 (Part 1)
ClosedActions

Y - Yes
N - No
Force Payment A 1   G$T,3 (Part 2)
ClosedActions

Y - Pay
N - Do not pay
End Date of Leave A 6 0 G$6,2 ddmmyy
Continued from Previous Pay Period A 1   GCONT
ClosedActions

Y - Yes
" - No

 
Comment A 8   GCLAIM  
Not Used A 13      
Account Number Override A 10   GACCT  
Job/Department Number Override A 8   GDEPT  
Generate DFU Record Number N 5 0 GDFU#  
Not Used A 42      
Entry Source A 3   GSRCE  
Source TXN ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Not Used A 40      
Job Costing Work ID A 3   GCWKID  
Not Used A 100      
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  
Not Used A 10      
Not Used A 10      
Not Used A 10      

 

ClosedTC E - Prepayment Totals
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC E
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GAPYS  
Taxable Gross N 9 2 G$7,1  
Tax Amount N 9 2 G$7,2  
Net Amount N 9 2 G$7,3  
Not Used A 45      
DFU Record Number N 5 0 GDFU#  
Not Used A 394      

 

ClosedTC K - Rebank Allowance/Deductions
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC K
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GAPYS  
Allowance/Deduction Code (1) A 2   G$T,1 Valid Allowance/Deduction code (PCTLAZ)
Allowance/Deduction Units (1) N 7 2 G$8,1  
Allowance/Deduction Value (1) N 9 2 G$7,1  
Allowance/Deduction Code (2) A 2   G$T,2 Valid Allowance/Deduction code (PCTLAZ)
Allowance/Deduction Units (2) N 7 2 G$8,2  
Allowance/Deduction Value (2) N 9 2 G$7,2  
Not Used A 18      
Account Number Override A 10   GACCT  
Job/Department Number Override A 8   GDEPT  
DFU Record Number N 5 0 GDFU#  
Costing Date N 6 0 GDATE ddmmyy
Not Used A 36      
Entry Source A 3   GSRCE  
Source TXN ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Not Used A 40      
Job Costing Work ID A 3   GCWKID  
Not Used A 100      
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  
Not Used A 10      
Not Used A 10      
Not Used A 10      

 

ClosedTC L - Rebank Worked Hours
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC L
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GAPYS  
Hours Type Code (1) A 2   G$T,1 Valid Hours Type code (PCTLAH)
Worked Hours (1) N 5 2 G$5,1  
Hours Value (1) N 9 2 G$7,1  
Hours Type Code (2) A 2   G$T,2 Valid Hours Type code (PCTLAH)
Worked Hours (2) N 5 2 G$5,2  
Hours Value (2) N 9 2 G$7,2  
Hours Type Code (3) A 2   G$T,3 Valid Hours Type code (PCTLAH)
Worked Hours (3) N 5 2 G$5,3  
Hours Value (3) N 9 2 G$7,3  
Not Used A 6      
Account Number Override A 10   GACCT  
Job/Department Number Override A 8   GDEPT  
DFU Record Number N 5 0 GDFU#  
Costing Date N 6 0 GDATE ddmmyy
Not Used A 36      
Entry Source A 3   GSRCE  
Source TXN ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Not Used A 40      
Job Costing Work ID A 3   GCWKID  
Not Used A 100      
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  
Not Used A 10      
Not Used A 10      
Not Used A 10      

 

ClosedTC M - Rebank Leave with Dates
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC M
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GAPYS  
Leave Hours Type A 2   G$T,1 Valid Hours Type code (PCTLAH) with A, L or S classification
Leave Hours N 5 2 G$5,1  
Leave Hours Value N 9 2 G$7,1  
Other Leave Reason A 2   G$T,2 Valid Leave Reason code (PCTLAA)
Start Date of Leave N 6   G$6,1 ddmmyy
Doctor's Cert./Authorised A 1   G$T,3(Part 1)
ClosedOptions

Y - Yes
N - No
Force Payment A 1   G$T,3 (Part 2)
ClosedOptions

Y - Pay
N - Do not pay
End Date of Leave N 6 0 G$6,2 ddmmyy
Continued from Previous Pay Period N 1   GCONT
ClosedOptions

Y - Yes
" - No
Comment A 8   GCLAIM  
Not Used A 13      
Account Number Override A 10   GACCT  
Job/Department Number Override A 8   GDEPT  
DFU Record Number N 5 0 GDFU#  
Not Used A 42      
Entry Source A 3   GSRCE  
Source TXN ID/Timestamp A 20   GTRNID  
User Entered A 10   GOEUSR  
Date Entered N 6 0 GOEDAT  
Time Entered N 6 0 GOETIM  
Last Change User A 10   GLCUSR  
Last Change Date N 6 0 GLCDAT  
Last Change Time N 6 0 GLCTIM  
Last Change Job A 10   GLCJOB  
Approval User A 10   GAUSR  
Approval Date N 6 0 GADAT  
Approval Time N 6 0 GATIM  
Costing Extract Batch ID A 10   GEXTID  
Labour Cost Code 1 A 10   GLCST1  
Labour Cost Code 2 A 10   GLCST2  
Labour Cost Code 3 A 20   GLCST3  
Not Used A 40      
Job Costing Work ID A 3   GCWKID  
Not Used A 100      
User Cost Code 4 A 10   GLCST4  
User Cost Code 5 A 10   GLCST5  
User Cost Code 6 A 10   GLCST6  
Not Used A 10      
Not Used A 10      
Not Used A 10      

 

ClosedTC N - Rebank Totals Record
Description Type Len Dec Field Name Field Format/Validation
Transaction Code A 1   GTC N
Employee Number A 6   GEMPNO  
Not Used A 1      
Pay Separator A 1   GPAYS  
Taxable Gross N 9 2 G$7,1  
Tax Amount N 9 2 G$7,2  
Net Amount N 9 2 G$7,3  
Not Used A 45      
DFU Record Number N 5 0 GDFU#  
Not Used A 10      
Not Used A 384